package com.iweibo.db;

/**
 * 数据库配置信息 
 * @author nibo
 * @date 2012-10-15
 *
 */
public class DBConfig {
	/**
	 * 
	 * @Description 数据库基本信息 
	 * @author nibo
	 * @date 2012-10-15
	 *
	 */
	public static class DB {
		/**数据库名称*/
		public static final String DB_NAME = "iweibo";
		/**数据库版本号*/
		public static final int DB_VERSION = 1;
	}
	
	/**
	 * 数据库表
	 * @author nibo
	 * @date 2012-10-15
	 *
	 */
	public static class Table {
		/**用户信息表名称*/
		public static final String USER_INFO_NAME = "USER_INFO";
		/**创建用户信息表*/
		//_id(主键id), USER_ID(用户id), USER_NAME(用户名), TOKEN(token), REMIND_IN(remind_in), EXPIRES_IN(expires_in), IS_DEFAULT(默认用户), USER_ICON(用户头像)
		public static final String USER_INFO_CREATE = "CREATE TABLE IF NOT EXISTS " + USER_INFO_NAME + " (_id INTEGER primary key autoincrement, " +
				"USER_ID INTEGER, USER_NAME VARCHAR(100), TOKEN VARCHAR(60), REMIND_IN INTEGER, EXPIRES_IN INTEGER, IS_DEFAULT INTEGER, USER_ICON BLOB)";
		/**删除用户信息表*/
		public static final String USER_INFO_DROP = "DROP TABLE IF EXISTS " + USER_INFO_NAME;
		
	}
	
	public static class SQL {
		
	}
	
	
	
}
